{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["README","HxReferralCodes","REG"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,2],[15,6,19,12]]}
[]
[null,"Referral Analysis",null,null,null,null,"NOTE:"]
[null,null,null,null,null,null,"This will only work if Vision is on DLM485 or above."]
[null,"Enter Date Range",null,null,"Active Patients = Applied and Permanent",null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[null,"FROM","TO",null,"Registration Status"]
[null,{"$f":"EOMONTH(TODAY(),-2)+1","v":"2017-03-01"},{"$f":"EOMONTH(TODAY(),-1)","v":"2017-03-31"},null,"ACTIVE PATIENTS",null,"Excel 2007 - Please enable both Macros... and Data Connections"]
[null,null,null,null,null,null,"Excel 2003 - If macros are disabled you will need to enable them via Tools menu > Macro > Security"]
[null,null,null,null,null,null,null,"On the Security Level tab > Select Medium. Then select the Trusted Publishers tab and tick \"Trust access to Visual Basic Project\""]
[null,null,null,null,null,null,null,"Click OK to close the Security window > Close Excel > Reopen this workbook and select \"Enable Macros\""]
[]
[null,"This will search referral Read codes used within the referral and/or medical history ",null,null,null,null,"Created:","2017-04-04"]
[null,"entities within the date range",null,null,null,null,"Version:",1.1000000000000001]
[null,"Using the specific Read codes listed on the HxReferralCodes tab",null,null,null,null,"Written by: Bradley Sieve"]
[null,"The REFERRALS tab will show data entered in the referral entity"]
[null,"The HXREFERRALS tab will show data entered in the medical history entity",null,null,null,null,"Disclaimer"]
[null,null,null,null,null,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]

{"sheet":"HxReferralCodes","index":1,"n_rows":85,"n_cols":2,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["READCODE","DESCRIPION"]
["64a6.00","8 week exam.abnormal -referred"]
["64B4.00","Birth exam. abnormal -referred"]
["64b5.00","Child 7 month examination abnormal referred"]
["64C4.00","10 day exam. abnormal-referred"]
["64D6.00","6 week exam.abnormal -referred"]
["64E6.00","8-9 mnth exam abnormal: refer"]
["64F6.00","18month exam.abnormal-referred"]
["64G6.00","2.5 year exam.abn.- referred"]
["64H6.00","3.5 year exam.abn.- referred"]
["64I6.00","4.5 year exam.abn.- referred"]
["64J6.00","10 year exam.abn. - referred"]
["64K6.00","15 year exam. abn.- referred"]
["64Q..00","Child: refer for surveillance"]
["64Q..11","Refer child for surveillance"]
["64Q3.00","Child referred to G.P."]
["64Q4.00","Child referred to consultant"]
["64Q7.11","Refer to child guidance"]
["64Q8.00","Child referred to orthoptist"]
["64QZ.00","Child specific referral NOS"]
["64R1.11","Child referral for audiology"]
["64R2.11","Child referral for audiometry"]
["64R3.11","Child referral- speech therapy"]
["64R4.11","Child referral to optician"]
["64R5.11","Child referral - ophthalmology"]
["64R6.11","Child referral-school psychol."]
["64R7.11","Child refer- clinical psychol."]
["64R8.11","Child referral - physiotherapy"]
["64R9.11","Child refer- community dentist"]
["64RA.11","Child referral-social services"]
["64U6.00","1 year exam.abnormal referred"]
["64V6.00","Child 6/12 exam abnorm: refer"]
["64W6.00","Child 21/12 exam abnorm: refer"]
["64X6.00","Child 3 yr exam abnorm: refer"]
["64Y6.00","Child 39/12 exam abnorm: refer"]
["66aE.00","Refer to osteoporosis specialist"]
["66aF.00","Refer for falls assessment"]
["66F7.00","Monoclonal paraprotein threshold for referral"]
["66Z0.00","Prostate specific antigen threshold for referral"]
["679m300","Referral to NHS Diabetes Prevention Programme declined"]
["679m400","Referral to NHS Diabetes Prevention Programme"]
["67W1.00","Recommendation self-refer for diabetes structured education"]
["67W2.00","Recommendation to self-refer for psychological treatment"]
["67W3.00","Recommendation to self-refer for counselling"]
["68W2300","Bowel scope (flexi-sig) screen: referred for colonoscopy"]
["8AB8.00","Referral to telehealth service"]
["8BM7.00","Shared care prescribing referred back to hospital"]
["8H%","Referral for further care"]
["8T%","Referral - additional"]
["94A%","Referral to coroner"]
["9b0g.00","Referral letter"]
["9bF3.00","Inbound referral"]
["9bF4.00","Outbound referral"]
["9c0B.00","Referral"]
["9D4..00","RM7 - refer patient to RMO"]
["9K0..00","Form GOS18 Ophthalmic referral"]
["9kf1.00","Refer COPD structured smoking assessment - enhanc serv admin"]
["9kf1.11","Referred for COPD structured smoking assessment"]
["9kN5.00","DMARD monitoring refer back to secondary care - enh serv adm"]
["9kN5.11","DMARD monitoring referred back to secondary care"]
["9N47100","Referral cancelled by patient"]
["9N6%","Referred encounter"]
["9Nc2.00","Referral letter sent"]
["9Nc2000","Referral letter sent by email"]
["9Nc2100","Referral letter sent by fax"]
["9NS0000","Referral for medication compliance assessment offered"]
["9NS0100","Referral for physical activity service offered"]
["9NS0200","Referral for smoking cessation service offered"]
["9NS0300","Referral to weight management service offered"]
["9NS0400","Referral for impaired glucose tolerance management offered"]
["9NS3.00","Not suitable for choice and booking referral"]
["9O6B.00","Child hearing screen failure referred to specialist"]
["9Og0.00","Falls risk assessment referral"]
["9OqH800","NAAASP init screen shows large AAA, referred to vasc service"]
["9P9..00","Referral for participation in clinical trial"]
["9QA..00","Referral for participation in research study"]
["9R35.00","Referred for part 3 accom."]
["9RE..00","Failure of electronic choose and book referral system"]
["9RF..00","Choose and book referral rejected by service provider"]
["9RG..00","Choose and book electronic referral letter sent"]
["F587200","Referred ear pain"]
["ZL5%","Referral to doctor"]
["ZL6%","Referral to nurse"]
["ZL7%","Referral to health worker"]
["ZL8%","Referral to professional allied to medicine"]

{"sheet":"REG","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Desc","Code"]
["ACTIVE PATIENTS"]
["Applied","REG001"]
["Permanent","REG002"]
["Temporary Resident < 16 days","REG003"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["NONE"]